Adaptive Join
Short Description
The Adaptive Join step allows for the use of nested loops or hash join method to be decided later
Detailed Description​
The Adaptive Join operator allows for the decision over the use of nested loops or hash join methods to be decided once the first pass through the data has been made.
Additional Links​
- Microsoft Documentation - Showplan Logical and Physical Operators Reference
- Microsoft Documentation - Explain Plans
- Plansplaining - Hugo Kornelis' Blog series
Search online​
If this article doesn't have the information you need you can try searching online. Remember, you can contribute suggestions to this page.